[insert_php]
global $wpdb;
$sql = “select post_content,post_title, post_name,guid,imagen, id ,ingles,frances,portugues,guid, colaborador, colaborador2, colaborador3 from wp_posts where post_type=’post’ and id in(select ingles from wp_posts where ingles like ‘%’)”;
$query = $wpdb->prepare($sql,’foo’);
$results = $wpdb->get_results($query);
$cont=0;
$cont=1;
$contb=0;
$colaborador1=””;
$colaborador2=””;
$colaborador3=””;
$ncolaborador1=””;
$ncolaborador2=””;
$ncolaborador3=””;
//$cont=0;
//while ($row = mysqli_fetch_row($result) /*and $cont<2*/ ){
foreach( $results AS $row ){
$colaborador2="";
$colaborador3="";
$enlace='https://africaactual.com/'.$row->post_name;
$enlace1=’https://africaactual.com/’.$row->post_name;
$foto=’‘.$row->post_title.’‘;
$row->post_content=strip_tags($row->post_content);
$contenido=substr($row->post_content,0,200).’ …
‘;
if($row->colaborador){
$sql2=’SELECT post_title,post_name from wp_posts where id=’.$row->colaborador;
$query2 = $wpdb->prepare($sql2,’foo’);
$results2 = $wpdb->get_results($query2);
foreach( $results2 AS $row2 ){
$colaborador1=$row2->post_title;
$ncolaborador1=$row2->post_name;
}
}
if($row->colaborador2){
$sql2=’SELECT post_title,post_name from wp_posts where id=’.$row->colaborador2;
$query2 = $wpdb->prepare($sql2,’foo’);
$results2 = $wpdb->get_results($query2);
foreach( $results2 AS $row2 ){
$colaborador2=$row2->post_title;
$ncolaborador2=$row2->post_name;
}
}
if($row->colaborador3){
$sql2=’SELECT post_title,post_name from wp_posts where id=’.$row->colaborador3;
$query2 = $wpdb->prepare($sql2,’foo’);
$results2 = $wpdb->get_results($query2);
foreach( $results2 AS $row2 ){
$colaborador3=$row2->post_title;
$ncolaborador3=$row2->post_name;
}
}
if(!empty($row->ingles))
$ingles=”“;
else
$ingles=””;
if(!empty($row->frances))
$frances= ““;
else
$frances=””;
if(!empty($row->portugues))
$portugues= ““;
else
$portugues=””;
$verMas= “Ver más“;
if(($cont-1)%3==0){
if ($contb%2==0){
echo(“
“;
$guid=”https://africaactual.com/”.$row->post_name;
echo “
“;
echo “
“;
echo “
“;
if($cont%3==0){
echo “
“;
echo”
“;
}
$cont++;
}
[/insert_php]